IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[csp_GetPINameInfoEd]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[csp_GetPINameInfoEd]
GO
--  csp_GetPIName 34224
CREATE PROCEDURE [dbo].[csp_GetPINameInfoEd]      
(      
	@piId int   
)        
AS        
BEGIN    

	select LastName + ' ' + FirstName as PIName 
	from INSIGHT_RPT_DB.dbo.AdmPerson 
	where id = @piId

END

GO

